package com.cac.demo.dao.cemopHandoverForm;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Mapper
@Repository
public interface CemopDeliverPlanDao {

    //新增MDS_Item表
    public int AddCemopMdsItem(@Param("map") HashMap map);

    public int insertCemopAdvancePosting(@Param("map")HashMap map);
    //新增质量信息表数据
    public int insertCemopWmsQualityInfo(@Param("map")HashMap map);
    //扫码移交-判断合格证号是否重复
    int queryPartHgzIsRepeat(@Param("barcode") String barcode, @Param("shop") String shop);
    //通过条码判断物料所属系统
    public String getSystemByBarcode(@Param("barcode") String barcode);//扫码移交

    public String getSystemByCoordinateId(String wmsDeliveryCoordinateId);//查询协调单关联的交接单

    public String getScenBackSystemByBarcode(@Param("barcode") String barcode);//扫码退回
    public String getSystemByid(@Param("wmsDeliveryPlanId") String wmsDeliveryPlanId);
    //根据物流编码查询数据
    public Integer searchByBarCodeCemop(@Param("barcode") String barcode);
    public List<String> getIdByBarcode(@Param("barcode") String barcode);
    public List<String> getShopByid(@Param("id") String id);

    public Integer changeTransferTypeCemop(@Param("id") String id, @Param("date") Date date, @Param("IP") String IP, @Param("userCode") String userCode);
    public List<HashMap> selectCemopCPIds(@Param("qualification") String qualification);
    public List<String> selectCemopCPId(@Param("qualification") String qualification);
    //根据合格证号修改物料移交状态
    public Integer changeCemopTransferTypeById(@Param("id")String id, @Param("date") Date date,@Param("IP")String IP,@Param("userCode")String userCode);
}
